ack! query failed:
  • errorno=1064
  • error=You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'and tp.categoryID= and tc.categoryID=ts.categoryID and
  • query=select distinct(productID) ,productName, con.companyID as 'companyid', companyName, productDescription, productPrice, fileSize, plateformOS, tp.registerDate, totalDownload from tblproductmaster tp, tblcategorymaster tc, tblcompanymaster con, tblsubcategorymaster ts where tp.oldSubCategoryID= and tp.categoryID= and tc.categoryID=ts.categoryID and ts.oldSubCategoryID=tp.oldSubCategoryID and ts.categoryID=tc.categoryID and con.companyID=tp.companyID and tp.status='1' AND FIND_IN_SET('1',tp.osSupported)